-- 8-1开启事务执行插入学生信息和修改学生信息操作
-- 开启事务
BEGIN;
-- 执行SQL语句
INSERT INTO	t_student(id,student_name,age,gender,birthday,classID,begin_year)VALUES(3006,'赵丽丽','女','2003-09-018',3,2023);
UPDATE t_student SET birthday='2003-10-02'WHERE student_name='赵丽丽';
INSERT INTO t_score(exam_score,studentID,courseID)VALUES(83。3066.1);
-- 提交事务
COMMIT;
-- 回滚事务
ROLLUP;
